IT Data Engineer

The IT Data Engineer is responsible for designing, developing and supporting the end to end data ecosystem to support the organization. This position is responsible for supporting data-driven capabilities throughout the organization, including areas such as business intelligence, reporting, data science and data analytics. The IT Data Engineer will work with the business and internal teams to prepare complex data analyses that help solve client problems and deliver significant measurable impact.

RESPONSIBILITIES/TASKS: 

• Hands on development of frameworks and applications for data processing.
• Analyze and evaluate data in relational databases and unstructured forms of data.
• Develop interactive dashboards, reports, and analysis templates.
• Implement and support a platform that can provide ad-hoc access to large datasets.
• Monitor the lifecycle of systems by being aware of obsolescence and release dates for the product.
• Review patch and upgrade information and ensure implementation where appropriate. 
• Track issues and errors, documenting resolutions.
• Production support on-call rotation.
• Ensure changes follow appropriate release management processes.
• Respond to and resolve reported application, data, or tool issues in a timely manner.
• Review change requests and provide an estimate of the effort required for completion.
• Collaborate with teams/partners to improve the overall operational maturity of the data ecosystem.
• Troubleshoot and resolve daily operational issues.  
• Design and implement an Enterprise Data Store consisting of a Landing Zone, and subject specific Staging and Mart databases using Replication, SSIS, T-SQL, and Stored Procedures.
• Design, code, test, and aggregate results from SQL queries to provide information to business users.
• Work with Project Manager in developing and executing project plans within assigned schedule and timeline.
• Determine Business Intelligence and Data Warehousing solutions to meet business needs.
• Manage the company’s Enterprise Data Store including:
  • Validate automated data feeds into the database.
  • Maintain validation processes to meet auditing requirements.
  • Ensure mapping tables and stored procedures are accurate and up to date.
  • Ensure outputs from the database are complete and accurate and meeting the needs of the reporting team
  • Ensure calculations performed within the SQL database are accurate.
  • Ensure accurate documentation and models are being maintained.
• Consistently improve, optimize, and maintain semantic models to achieve peak performance across the entire analytics platform.
• Work closely with the business units to gather requirements, draft prototypes, and document changes until a final version is accepted and signed off on.
• Leads data mapping and analysis efforts to build a better view of our internal data assets and makes recommendations on how and where to reduce redundancy. 
• Work closely with strategic projects and coach development teams on defined standards and methods for data usage and propagation.
• Identify and resolve data reporting issues in a timely fashion.

This position description identifies the responsibilities and tasks typically associated with the performance of the position.  Other relevant essential functions may be required.

EDUCATION:

Bachelor’s degree in computer science, mathematics, analytics, or equivalent discipline. Combinations of relevant education, certifications, and experience may be considered in lieu of a degree. Continuous learning, as defined by the Company’s learning philosophy, is required. Certification or progress toward certification is highly preferred and encouraged.

EXPERIENCE: 

Five years in a Data Warehousing environment is required, including two years of SQL (T-SQL), SQL Server, SSIS, ETL, and data integration experience required. Cloud (AWS or Azure) experience utilizing Snowflake, and Insurance industry experience a plus.

SKILLS/KNOWLEDGE/ABILITIES (SKA) REQUIRED:

• Knowledge of data warehouse concepts, dimensional data modeling, and complex interdependent SQL processes. 
• Knowledge of SAFe Agile development practices.
• Skilled in information delivery concepts, design, and development using modern reporting tools. 
• Experience working in a large data warehouse environment with complex data models. Strong problem solving and data analysis skills.
• Strong proficiency in SQL and SSIS.
• Excellent oral and written communication skills required, with demonstrated ability to lead a collaborative conversation with IT and business leaders in a technical and non-technical context. 
• Ability to analyze and model normalized and dimensional data structures.
• Excellent problem solving, and critical thinking skills.
• Ability to work independently and collaboratively with cross-functional teams.
• Ability to manage multiple and competing projects/priorities.
• Outstanding communication skills.
• Cross group collaboration and interpersonal skills. 

WORKING CONDITIONS:

Work is performed in an office setting with no unusual hazards. 

The qualifications listed above are intended to represent the minimum education, experience, skills, knowledge and ability levels associated with performing the duties and responsibilities contained in this job description. 

We are an Equal Opportunity Employer.  Diversity is valued, and we will not tolerate discrimination or harassment in any form. Candidates for the position stated above are hired on an "at will" basis.  Nothing herein is intended to create a contract.