Role: Data Modeler Location: Chicago, IL or Tempe, AZ (Hybrid 3 days onsite in every week) Duration: 7 Months
Job Description: Client's Metrics & Analytics is looking for highly experienced Senior Data Modeler. As Client evolves to the next level of dashboards and creates a more cohesive and flexible user experience, we are looking for a data modeler to more quickly move us to our destination. The Senior Data Modeler will help create a foundational data model to underpin interactive PowerBI reports and dashboards that provide insights and help drive key business decisions for internal clients.
Contractor’s Role: Senior Data Modeler. 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. Ensure performance, security, and scalability.
Experience Level: Level 3- [senior- 8+ years overall experience]
Qualifications (Must Have’s): Senior Data Modeler will have extensive and exceptional data modelling and SQL skills with strong PowerBI development skills. He or she will have 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. The modeler will need to be 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. He or she will be creative and by able to apply his or her experience on a regular basis. 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 • 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
Nice to Haves: • 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
Tasks & Responsibilities The Senior Data Modeler 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. • 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.
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $60.00/hr.
