Synectics
Data Engineer - Analytics
Synectics, Chicago, Illinois, United States, 60290
Job Description :
Data Architect will work independently under the Product Manager to expand the common data model that is designed to ensure that metrics and other data are consistent across all dashboards with proper performance, security, and scalability. Ensure performance, security, and scalability. Work closely with the Product Manager to develop and expand the core data model and its capabilities. Participate in knowledge transfer sessions to quickly learn and apply our data schemas and metrics. Create, develop and improve conceptual and logical data models. Implement relational data models and maintain data dictionary. Collaborate with data architects and data engineers to ensure alignment of model. Collaborate with BAs and PowerBI developers who will implement the model. Follow guidelines and best practices and help define design standards for enterprise data model development. Work proactively and independently to address requirements and articulate issues/challenges to reduce delivery risks. Ensuring metrics and other data are consistent across dashboards Think through, design, & explain the "why" behind model architecture Work Model: Hybrid - onsite 3 days per week Qualifications
8-12 Years of overall development experience 3+ Years of PowerBI Development that demonstrates advanced skills 10+ Years of SQL experience modelling data and writing complex queries Extensive and exceptional data modelling and SQL skills with strong PowerBI development skills. Previously created data models to support application development frameworks and can derive data driven application capabilities from code driven application code. Some PowerBI experience with DAX Measure, Bookmarks and Field parameters to create flexible user-defined PowerBI experiences is also needed. SQL skills will also be extensive; able to support others and quickly adapt the model to write the SQL to populate the framework as well as determine the best way to apply the framework to various dashboards. Creative and by able to apply his or her experience on a regular basis. GIT for version control Expertise with ETL, data modeling Expertise with complex SQL queries Problem-solving and troubleshooting skills Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required. Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required. Strong communication and collaboration skills Object-Oriented Framework development is a plus Experience with Azure (ADF, ADLS, Synapse) a plus Experience with Collibra and/or other Data governance tools a plus
Benefits:
Healthcare Insurance: Synectics offers eligible employees and their dependents healthcare coverage through BlueCross BlueShield of Illinois. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Premiums are subsidized by Synectics.
Dental Insurance: Synectics offers eligible employees and their dependents a dental plan through MetLife. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.
Vision Insurance : Synectics offers eligible employees vision insurance through VSP. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.401(k) Plan: The Synectics Inc. Investment Savings Retirement Plan. Synectics offers all employees who are 21 years of age or older the opportunity to invest in the 401(k) Plan on the first enrollment date that is at least 30 days after employment begins. Enrollment dates are each January 1st, April 1st, July 1st, and October 1st.
Technical Certification Bonus: Synectics is pleased to award its employees a bonus of up to $500 for an approved professional certification. In determining the bonus amount, Synectics will consider the cost of the test(s) for any certification relating to your current position, achieved during your employment with us. Only one Certification Bonus per calendar year may be awarded per employee. Only current, active employees will be eligible to receive this bonus. It will be awarded 90 days after the Synectics office has received documentation confirming the successful completion of the certification.
Synectics is an equal opportunity employer.
Data Architect will work independently under the Product Manager to expand the common data model that is designed to ensure that metrics and other data are consistent across all dashboards with proper performance, security, and scalability. Ensure performance, security, and scalability. Work closely with the Product Manager to develop and expand the core data model and its capabilities. Participate in knowledge transfer sessions to quickly learn and apply our data schemas and metrics. Create, develop and improve conceptual and logical data models. Implement relational data models and maintain data dictionary. Collaborate with data architects and data engineers to ensure alignment of model. Collaborate with BAs and PowerBI developers who will implement the model. Follow guidelines and best practices and help define design standards for enterprise data model development. Work proactively and independently to address requirements and articulate issues/challenges to reduce delivery risks. Ensuring metrics and other data are consistent across dashboards Think through, design, & explain the "why" behind model architecture Work Model: Hybrid - onsite 3 days per week Qualifications
8-12 Years of overall development experience 3+ Years of PowerBI Development that demonstrates advanced skills 10+ Years of SQL experience modelling data and writing complex queries Extensive and exceptional data modelling and SQL skills with strong PowerBI development skills. Previously created data models to support application development frameworks and can derive data driven application capabilities from code driven application code. Some PowerBI experience with DAX Measure, Bookmarks and Field parameters to create flexible user-defined PowerBI experiences is also needed. SQL skills will also be extensive; able to support others and quickly adapt the model to write the SQL to populate the framework as well as determine the best way to apply the framework to various dashboards. Creative and by able to apply his or her experience on a regular basis. GIT for version control Expertise with ETL, data modeling Expertise with complex SQL queries Problem-solving and troubleshooting skills Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required. Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required. Strong communication and collaboration skills Object-Oriented Framework development is a plus Experience with Azure (ADF, ADLS, Synapse) a plus Experience with Collibra and/or other Data governance tools a plus
Benefits:
Healthcare Insurance: Synectics offers eligible employees and their dependents healthcare coverage through BlueCross BlueShield of Illinois. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Premiums are subsidized by Synectics.
Dental Insurance: Synectics offers eligible employees and their dependents a dental plan through MetLife. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.
Vision Insurance : Synectics offers eligible employees vision insurance through VSP. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.401(k) Plan: The Synectics Inc. Investment Savings Retirement Plan. Synectics offers all employees who are 21 years of age or older the opportunity to invest in the 401(k) Plan on the first enrollment date that is at least 30 days after employment begins. Enrollment dates are each January 1st, April 1st, July 1st, and October 1st.
Technical Certification Bonus: Synectics is pleased to award its employees a bonus of up to $500 for an approved professional certification. In determining the bonus amount, Synectics will consider the cost of the test(s) for any certification relating to your current position, achieved during your employment with us. Only one Certification Bonus per calendar year may be awarded per employee. Only current, active employees will be eligible to receive this bonus. It will be awarded 90 days after the Synectics office has received documentation confirming the successful completion of the certification.
Synectics is an equal opportunity employer.