Principal Solutions Architect, Power BI

Job#: 2043918

Job Description:

Position: Power BI Solutions Architect
Location: Temple, TX or Carrollton, TX
Hybrid: 2 days per week onsite
Rate: $80-90/hr W-2
Hire type: 6 month contract to hire
ESSENTIAL JOB FUNCTIONS / PRINCIPAL ACCOUNTABILITIES:

• Design end to end analytical workflows, including overall architecture, capabilities, platforms, tools, and governing processes.
• Develop complex dimensional data models using Power BI, Produce actionable metrics using advanced DAX skills
• Use Power Query to transform and load data to create compelling data visualizations with Power BI
• Create, maintain, and communicate positioning and go-forward strategies for analytical capabilities and tools.
• Define and improve best practices, guidelines, and integration with other enterprise solutions.
• Review analytic solutions for re-usability, scalability, synergy opportunities and alignment to defined best practices and guidelines.
• Create and evolve analytic technology roadmap, to align with continuously evolving business needs.
• Collaborate with governance leader to ensure architectural alignment to enterprise governance requirements and inform of implementation feasibility.
• Monitor technology trends and perform discovery of any new tools and capabilities of interest.
• Benchmark analytic capabilities with industry analysts and other companies.
• Own strategic technology relationships with technology vendors and external communities/partners.
• Lead education and training for analytics community.
• Perform other duties as assigned.

• Bachelor’s degree in computer science, statistics, engineering, or a related field.
• Seven or more years demonstrating a high degree of proficiency in designing and developing complex, high-quality analytical solutions on cloud and other modern data platforms and tools.
• Five or more years in a Data Architecture role designing data and analytics solution architectures, detailed workflows, data modeling, applying data engineering and architecture best practices, and governance guidelines and advising on necessary technologies.
• Experience with designing and maintaining data warehouses and/or data lakes with big data technologies such as Spark/Databricks, or distributed databases, like Redshift and Snowflake, and experience with housing, accessing, and transforming data in a variety of relational databases.
• Experience in building data pipelines and deploying/maintaining them following modern DE best practices. (e.g., DBT, Airflow, Spark, Python OSS Data Ecosystem)
• Knowledge of Software Engineering fundamentals and software development tooling (e.g., Git, CI/CD, JIRA) and familiarity with the Linux operating system and the Bash/Z shell.
• Experience with cloud database technologies (e.g., Azure) and developing solutions on cloud computing services and infrastructure in the data and analytics space.
• Basic familiarity with BI tools. (e.g., Alteryx, Tableau, Power BI, Looker)
• Expertise in ELT and data analysis, SQL primarily.
• Conceptual knowledge of data and analytics, such as dimensional modelling, reporting tools, data governance, and structured and unstructured data.
• Ability to work with customer’s business requirements to create best-case solutions.
• Ability to communicate vision to both technical and leadership audiences.
• Ability to building demos and proof of concepts.
• Ability to act as a consultant on architecture and implementation.

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.