Job Closed
This listing is no longer active.
Augmented Capital Program Consulting Services™
Power BI Developer
Location
United States
Posted
76 days ago
Salary
0
Seniority
Senior
Job Description
Power BI Developer
Consertus
• Design and develop Power BI semantic models, dashboards, and paginated reports aligned to client requirements • Build and optimize DAX measures, Power Query (M) transformations, and row-level security • Engage with stakeholders to gather requirements and translate functional needs into technical specifications and scalable data models • Build SSRS reports and contribute to SSAS tabular model development as part of broader BI architectures • Develop and maintain ETL processes using SSIS, Power Query, Azure Data Factory, or similar tools, including data profiling and quality validation • Develop KPIs and performance metrics to support operational and strategic decision-making • Perform testing, validation, performance tuning, and support user acceptance testing (UAT) • Manage assigned tasks and workstreams across concurrent client engagements, proactively communicating progress, risks, and blockers • Demonstrate ownership of assigned deliverables, ensuring quality, timeliness, and alignment with client expectations • Participate in client-facing meetings, demos, and walkthroughs, presenting solutions clearly and professionally • Produce clear, well-structured documentation including data dictionaries, technical designs, and user guides • Contribute to internal best practices, reusable assets, and continuous improvement initiatives
Job Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, Business, or a related field
- 3+ years of experience developing Power BI dashboards and reports
- Strong experience with DAX, Power Query (M), and semantic data modeling
- Solid understanding of star schema and tabular modeling principles
- Hands-on experience with SQL Server Reporting Services (SSRS)
- Experience with ETL tools such as SSIS or equivalent data integration technologies
- Strong SQL / T-SQL skills, including joins, aggregations, and performance tuning
- Experience working with large datasets and multiple data sources
- Strong analytical and problem-solving skills
- Effective written and verbal communication skills
- Microsoft certifications such as PL-300, or progress toward DP-500 / DP-600
- Experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake)
- Familiarity with Azure data services (Azure SQL, Synapse, Data Lake)
- Experience with Git-based version control and deployment pipelines
- Exposure to additional BI tools (e.g., Tableau, Qlik, Oracle BI Publisher)
- Experience working with APIs (REST/SOAP) and handling JSON/XML data structures is a plus
- Exposure to data warehousing concepts, including staging, data marts, and dimensional modelling
- Understanding of capital project, construction, or asset lifecycle data is a plus
- Ability to manage multiple priorities and work effectively in a consulting environment
Benefits
- Comprehensive health coverage (medical, dental, and vision)
- Company-paid life and disability insurance
- Optional benefits like pet insurance, legal, and supplemental health plans
- 401(k) with day-one eligibility, 3% safe harbor, plus up to 2.5% company match
- Generous time off: 10 paid holidays and PTO starting at 15 days, growing up to 25
- Access to Consertus Academy for continuous learning and development
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Developer Jobs
Business Intelligence Analyst – Contract
The Motley FoolMaking the world smarter, happier, and richer through free and premium investing guidance.
• Analyze datasets containing millions of records to identify trends, patterns, and exploratory insights. • Apply statistical methods and machine learning algorithms to solve complex business problems and forecast outcomes. • Partner with business teams to understand their strategy and goals, then translate them into actionable data initiatives. • Develop and maintain dashboards in Tableau that provide clear, jargon-free insights. • Work with data engineering and tech colleagues to automate and operationalize your models. • Provide data-informed recommendations with a quantifiable value to improve product features, engagement, and member experience. • Monitor key metrics and performance indicators to develop strategies for business impact.
• The Senior SharePoint & Power BI Developer is responsible for designing, developing, and maintaining secure collaboration platforms and advanced data visualization solutions in support of federal and enterprise programs. • This role translates business, technical, and operational requirements into scalable SharePoint environments and actionable Power BI dashboards that enable informed decision-making, performance tracking, and compliance reporting. • The individual will work closely with program leadership, technical teams, and government stakeholders to ensure solutions meet security, usability, and governance standards while supporting mission and operational objectives. • Design, configure, and maintain SharePoint Online and/or SharePoint Server environments. • Develop and manage Document libraries with structured metadata and taxonomy. • Ensure SharePoint implementations align with federal IT and cybersecurity standards.
• We’re seeking a Business Intelligence Analyst, a role that combines strong technical expertise with strategic thinking and a deep understanding of how data drives business decisions. • The ideal candidate is comfortable owning projects end-to-end — from translating business questions into data requirements to delivering polished, executive-ready dashboards and insights. • You should be highly analytical and detail-oriented, with the ability to manage multiple high-priority initiatives simultaneously. • You must be confident working with complex, multi-source datasets and capable of identifying discrepancies, troubleshooting issues, and ensuring data integrity. • Communicate findings clearly to non-technical stakeholders, translating data into actionable recommendations. • In a media and marketing analytics environment, looking for someone who understands campaign performance metrics, audience measurement, and cross-channel reporting. • You should have experience building client-facing dashboards and be comfortable operating in fast-paced, deadline-driven settings where accuracy and presentation quality are critical.
• Build and maintain the “single source of truth” for marketing performance across Meta, Google, TikTok, and other channels • Track and analyze core KPIs including ROAS, MER, CAC, LTV, AOV, retention, and cohort performance • Conduct deep-dive analyses to answer critical business questions (e.g., creative performance, channel efficiency, customer quality) • Partner with marketing and media buying teams to improve attribution visibility and decision-making • Use Domo (Magic ETL, Beast Mode, SQL) to clean, transform, and model data from Shopify, Klaviyo, and AWS data sources • Design and build executive-grade dashboards that are intuitive, actionable, and mobile-friendly • Develop calculated fields and business logic for e-commerce metrics (e.g., contribution margin, blended CAC, MER) • Ensure data accuracy, consistency, and reliability across all reporting layers • Act as the bridge between data engineering and business teams, translating requirements into scalable reporting solutions • Define requirements for new data pipelines and integrations with engineering partners • Enable stakeholders by training teams on Domo usage, alerts, and self-serve analytics capabilities




