Contact Us 877.823.3669

Sr. SQL Data Solutions Architect in Rocky Hill, CT at SNI Technology

Date Posted: 6/7/2019

Job Snapshot

Job Description

Full Time Opportunity---Great benefits, great people, work from home options

Very Interesting role, part of building out something new for an exciting company.

MUST HAVE TREMENDOUS SQL SKILLS

The ideal candidate is an experienced data architect who enjoys optimizing data schemas and building them from the ground up.

Responsibilities:

  • Develops data architecture plans and executes them in collaboration with Data Owners, Solution Architects & Technology Leads.
  • Defines and enforces data architecture standards, procedures, metrics, and policies to ensure consistency and adherence processes to ensure that is operational.
  • Translate advanced business analytics problems into technical and data design approaches that yield actionable recommendations across multiple, diverse domains. Creates, maintains, and communicates current and target state data architecture for data domains within an assigned subject area.
  • Guides application development teams in the data design of complex solutions and ensures that teams are in alignment with the data architecture principles, standards, strategies, and target states.
  • Facilitates the transition from high level design and supports the project life cycle with input from management where needed.


Desired Skills and Experience:

  • Bachelor's degree and 8-10+ years of relevant professional experience.
  • Robust Data Architecture skills - sets direction for and possesses a deep understanding of data architecture patterns which integrate with industry trends.
  • Experience in data management, data warehousing, data modeling, and business intelligence, and/or master data management, metadata management concepts and ETL frameworks.
  • Experience in Agile development processes.
  • Experience with large-scale, Hadoop big data methods, such as Spark, Scala, NiFi.
  • Experience with AWS Cloud based data storage and processing technologies.
  • Strong experience with SQL Server and/or Oracle or any other database platforms.
  • Ability to independently learn new technologies and data related approaches.
  • Effective writing and presentation skills.
  • Experience working with financial and accounting systems is preferred. Specific experience with Intacct accounting system is a plus.
  • Experience with relational SQL databases, including SQL server and Postgres.
  • Experience with AWS cloud services: EC2, EMR, RDS, Redshift.
  • Nice to have experience with reporting /data visualization tools.
  • Nice to have experience with BI tools: Tableau, QlikView, Domo, etc.