SUMMARY:
The IT Data Engineer II 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 II 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 biweekly 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 a change request and provide an estimate on effort required for completion.
* Collaborate with teams/partners to improve overall operational maturity of the data ecosystem.
* Troubleshoot and resolve daily operation issues.
* Design and implement an Enterprise Data Store consisting of a Landing Zone, and subject specific Staging and Mart databases using Replication, SSIS, SSAS, T-SQL and Stored Procedures.
* Work with business stakeholders to create and maintain reports in SSRS and PowerBI using relational and SSAS data sources.
* 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 a ccurate and meeting the needs of the reporting team.
- 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 into our internal data assets and makes recommendations on how and where to reduce redundancy.
* Work closely with strategic projects and coaches development teams on defined standards and methods for data usage and propagation.
* Identify and resolve data reporting issues in a timely fa shion.
* Design and develop key analytics capabilities using SSAS tabular modeling.
This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.
EMPLOYMENT QUALIFICATIONS:
EDUCATION:
Bachelor's degree in computer science, mathematics, analytics, or equivalent discipline. 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 required, including two years of SQL (T-SQL), SQL Server, SSIS, SSRS, ETL and data integration experience required. Experience with BI tools and reporting platforms ( PowerBI, Tableau, Cognos, or Business Objects) preferred. Experience developing SSAS tabular models with large and complex datasets, Cloud (AWS or Azure) experience 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 Agile development practices.
* Skilled in information delivery concept, 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, Power BI, and SSRS.
* 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.
