Data Engineer I Modeler

Job#: 2037211

Job Description:

Apex Systems is looking for an experience Business Intelligence Lead, who has strong data visualization and dashboard creation experience with PowerBI. The Business Intelligence Lead will need to be well versed in all things SQL. The Business Intelligence Lead will need to be comfortable working with development teams, working directly with end-users (business sponsors) and be comfortable reviewing visualizations and dashboards with Director and VP level individuals.
This role sits on-site in Lake Mary, FL or Pittsburgh, PA 2-3 days per week. We are not accepting remote only candidates at this time. 

***No 3rd Party or C2C Resumes will be accepted for this position***
Primary Functions/Job Description:

• Works directly with business leaders to understand the business needs, critical path, and timeline to meet project goals.
• Develops business intelligence solutions to fulfill short and long-term priorities with solutions ranging from traditional, to more modern, interactive reporting tools.
• Leverages an analytic mindset to develop visualization of key trends and insights for decision making.
• Communicates/interacts with business partners up to the VP level.
• Collaborates with development team, project managers, and business analysts to determine requirements and develop solutions to meet business goals.
• Develops relational and dimensional data models to support reporting and analytics (SQL Server BI Platform).
• Assists leadership with advocating for and maturing the BI program using the latest methodologies as well as classic data warehouse and operational data store design patterns.
• Supports production reporting and data warehouse environments including shared after-hours rotation.
• Leads design and code reviews of BI solutions.

• Bachelor’s degree in computer science engineering or a related discipline, or equivalent work experience required.
• 10+ years of progressive experience in Database Development/Data Engineering/Data Warehouse/BI Reporting (Data Management) related functions/roles.
• 5+ years of professional experience in Reporting Applications.
  • Must have 3+ years working with PowerBI minimum; with ideal candidate having 5+ years of PowerBI.
  • Extensive experience in creating data visualizations and dashboards from scratch.
  • Experience driving requirements gathering process and designing visualizations and dashboards.
• 7-10+ years of SQL development:
  • Advanced knowledge of SQL, database technologies, and data warehouse design philosophies including dimensional modelling, Star, & Snowflake schema.
  • Expert SQL development skills including, but not limited to, table design, queries, table-valued functions, window functions, and index optimization.
• Knowledge of connecting to a disparate data stores and combine data to develop reports.
• Knowledge in financial risk reporting – KRIs and KPIs.
• Strong experience in SDLC, DevOps processes – CI/CD tools, Git, etc.
• Knowledge of Scrum and XP methodologies and ability to work in a fast paced and rapidly changing environment.
• Strong analytical skills and attention to detail.
• Strong desire to improve data quality and performance.
• Knowledge in data pipelines and snowflake databases.

***No 3rd Party or C2C Resumes will be accepted for this position***
Jason Biser
Application Delivery Lead
Apex Systems
[email protected] 
 

EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.