InGenesis, Inc.
Posted 33 days agoVerified live 2d ago
Business Intelligence Data Specialist - (13357)
Brief overview
Remote
Power BISQL ServerT-SQLSQL Server Reporting Services (SSRS)Data warehousingData modelingETL processesAzure Data FactoryAzure DevOpsFinancial and operational reportingWritten and verbal communication
About the company
InGenesis, Inc.ingenesis.com
InGenesis is a staffing and recruiting company specializing in payrolling and talent acquisition services.
Job description
Summary
InGenesis, Inc. is a healthcare services firm providing health and workforce solutions. The Business Intelligence Data Specialist designs, develops, maintains, and supports business intelligence and analytics solutions, including reports, dashboards, data models, and ETL processes. The role also collaborates with stakeholders and IT to support strategic analytics, data management, and protection needs.
Responsibilities
- Translate business needs to technical specifications
- Design, develop, test, and deploy SQL Server Reporting Services (SSRS) and Power BI reports and dashboards to meet client needs
- Troubleshoot data integrity issues within existing data warehouse
- Analyze existing data sets in order to design and develop new data models
- Design, develop, and maintain ETL processes to build new data models and ensure data is accurate and current
- Collaborate with stakeholders to develop a strategic vision for their BI and analytic needs
- Collaborate with IT to identify and implement data management and protection solutions and processes for the business intelligence and analytics solutions
- Provide end-user support
- Create and maintain system documentation as changes are implemented
- Perform other duties as assigned to meet departmental or company needs
Skills
- Familiarity with Microsoft BI environment. (SQL Server, .NET, SSRS and/or Power BI)
- Understanding of developing and distributing Microsoft Power BI reports
- Strong understanding of data warehouse concepts, structures, and best practices
- Comfortable analyzing existing source data systems to design and develop new data models
- Ability to work both collaboratively and individually
- Strong T-SQL skillset
- Familiarity with Azure DevOps
- Comfortable using ETL tools such as Azure Data Factory, Logic Apps, SSIS or Informatica
- Comfortable using a variety of data sources (SQL, text, XML, CSV, MS Azure, Flow, Logic Apps)
- Ability to work independently, manage time effectively, and meet deadlines in a fully remote environment
- Strong written and verbal communication skills using phone, email, and virtual collaboration tools
- Detailed-oriented and reliable, with a commitment to accuracy, confidentiality, and quality standards
- This position is available only in approved work locations. The role is not open to applicants who reside in or will perform work in jurisdictions with compensation disclosure requirements that apply to this position. Work location eligibility will be confirmed during the application process
- Frequently required to operate a computer and file and retrieve written documents
- Physical demands may include but are not limited to standing, sitting, walking, lifting, carrying, reaching, handling, kneeling, crouching, and bending
- Experience with On-prem Power BI preferred
- Experience with SQL Server Reporting Services (SSRS) preferred
- Experience in financial and/or operational reporting preferred
Qualifications
Must Haves
- Familiarity with Microsoft BI environment. (SQL Server, .NET, SSRS and/or Power BI)
- Understanding of developing and distributing Microsoft Power BI reports
- Strong understanding of data warehouse concepts, structures, and best practices
- Comfortable analyzing existing source data systems to design and develop new data models
- Ability to work both collaboratively and individually
- Strong T-SQL skillset
- Familiarity with Azure DevOps
- Comfortable using ETL tools such as Azure Data Factory, Logic Apps, SSIS or Informatica
- Comfortable using a variety of data sources (SQL, text, XML, CSV, MS Azure, Flow, Logic Apps)
- Ability to work independently, manage time effectively, and meet deadlines in a fully remote environment
- Strong written and verbal communication skills using phone, email, and virtual collaboration tools
- Detailed-oriented and reliable, with a commitment to accuracy, confidentiality, and quality standards
- This position is available only in approved work locations. The role is not open to applicants who reside in or will perform work in jurisdictions with compensation disclosure requirements that apply to this position. Work location eligibility will be confirmed during the application process
- Frequently required to operate a computer and file and retrieve written documents
- Physical demands may include but are not limited to standing, sitting, walking, lifting, carrying, reaching, handling, kneeling, crouching, and bending
Nice to Haves
- Experience with On-prem Power BI preferred
- Experience with SQL Server Reporting Services (SSRS) preferred
- Experience in financial and/or operational reporting preferred
Benefits
- This position is fully remote.
