BI Data Engineer

Posted 2 days agoViewed

View full description

💎 Seniority level: Senior, 5+ years

📍 Location: AZ, CA, CO, CT, FL, GA, IL, MA, NV, NJ, NM, NY, OH, OR, PA, TX, VA, WA

💸 Salary: 105000.0 - 120000.0 USD per year

🔍 Industry: Software Development

🏢 Company: Committee for Children

🗣️ Languages: English

⏳ Experience: 5+ years

🪄 Skills: SQLBusiness IntelligenceData AnalysisETLMicrosoft SQL ServerData engineeringCommunication SkillsAnalytical SkillsCollaborationMicrosoft ExcelProblem SolvingRESTful APIsCritical thinkingReportingTroubleshootingJSONData visualizationFinancial analysisData modelingScriptingData analyticsData managementSaaS

Requirements:

5+ years’ experience working with relational database systems
5+ years’ experience performing business and financial analysis
3+ years’ experience working with Power BI to develop reports and dashboards
Advanced proficiency in Power BI (Power Query M, DAX), Power Automate, Excel, SQL, and Microsoft Fabric Analytics
Experience with ETL processes, data warehousing, subscription business models, and SaaS KPIs
Experience with ERP systems (NetSuite preferred)
Experience with different data warehouse designs
Ability to prioritize tasks and manage work efficiently maintaining a high level of productivity
Demonstrated ability to navigate and articulate the workflow between data warehousing, data transformation, and reporting tools to ensure accuracy and relevance of insights generated
Experience working independently and in a team-oriented, collaborative environment
Strong critical thinking, analytical, and problem-solving skills
Sound decision making, discretion, and confidentiality

Responsibilities:

Develop and maintain datasets, data models, and data visualizations to support business decisions
Develop different data warehouse designs like star schema, snowflake schema, and dimensional modeling
Identify data sources, definitions, and timelines appropriate for analysis
Write, optimize and maintain complex SQL queries to support data analysis and reporting needs
Develop and generate ad hoc reports based on stakeholder requirements to support decision making processes in various departments
Work with Fabric to connect to various data sources such as databases, cloud storage, or APIs
Integrate data warehouse with business intelligence tools to create reports and dashboards
Design and build interactive reports using Power BI to present findings and identify trends to stakeholders
Ensure data quality and integrity by identifying and resolving data issues
Perform root cause analysis and uncover core issues using data, then assist the organization to improve
Analyze and interpret various sources of internal data and external data sources to support business decision-making
Design, build and maintain automated workflows using Power Automate to streamline business processes
Identify opportunities for process improvement and develop solutions to reduce manual effort

Apply