Apolis · 1 month ago
Data Consultant (PostgreSql & PowerBI)
Raleigh, NC
Full-time
Hybrid
Senior Level
$45/hr - $50/hr
6+ years expApolis is a company focused on enterprise solutions, and they are seeking a Data Consultant with expertise in PostgreSQL and Power BI. The role involves supporting enterprise value realization activities through data integration, designing SQL queries, and developing interactive dashboards in Power BI.
ConsultingEnterprise ApplicationsEnterprise Resource Planning (ERP)Information TechnologyIT InfrastructureIT ManagementMobileSoftwareWeb Hosting
Responsibilities
Work to support enterprise value realization framework activities to help:
Data and technical integration elements
Detailed designs and implementations
Work with third party tools and platforms and understand existing data model
Design, write, and optimize SQL queries in PostgreSQL
Extract, aggregate and transform large data sets
Create custom tables, views, procedures, and functions to support reporting
Develop Power BI dashboards and reports that present datasets in clear, intuitive, and interactive way
Connect Power BI to PostgreSQL to build and manage data models and relationships
Implement custom filters, drilldowns, and bookmarks to enhance user experience
Collect, clean, and validate data from multiple source tables and ensure accuracy, completeness, and consistency are maintained
Qualification
Required
PostgreSQL & Power BI
Advanced level (6-9 years experience) in PostgreSQL & Power BI
Experience in data and technical integration elements
Ability to create detailed designs and implementations
Experience working with third party tools and platforms
Understanding of existing data models
Ability to design, write, and optimize SQL queries in PostgreSQL
Experience in extracting, aggregating, and transforming large data sets
Ability to create custom tables, views, procedures, and functions to support reporting
Experience in developing Power BI dashboards and reports
Ability to connect Power BI to PostgreSQL to build and manage data models and relationships
Experience in implementing custom filters, drilldowns, and bookmarks in Power BI
Ability to collect, clean, and validate data from multiple source tables
Ensuring accuracy, completeness, and consistency of data
Company
Apolis
Apolis is a IT consultancy that offers provides ERP solutions, hosting, assessment, web and mobile, IT staffing and IT workforce solutions.
501-1000 employees
H1B Sponsorship
Apolis has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (15)
2022 (15)
2021 (12)
2020 (122)
Funding
Current Stage
Late StageLeadership Team
Amar Shokeen
President/ CEO
Rita Shokeen
COO
Company data provided by crunchbase