About this role
Senior Data Analyst role supporting data warehousing and BI for a federal government client. Designs data marts, validates data, and ensures governance across enterprise data assets using ERwin and Power BI.
Key Responsibilities
- Data warehousing design and modeling
- Data mart development
- Data validation and governance
- Client collaboration
- Production BI deployment
Technical Overview
Heavy emphasis on SQL, data warehousing concepts, dimensional modeling, data marts, and cloud platforms (AWS/Azure/GC). Utilizes ERwin for data modeling and Power BI for analytics and visualization.
Ideal Candidate
The ideal candidate is a senior data analyst with 10+ years of data warehousing experience, expert SQL, ERwin, and Power BI skills, and experience designing data marts using dimensional modeling for federal government clients. Must be a US citizen or green card holder able to obtain Public Trust clearance.
Must-Have Skills
Bachelor's degree in Computer ScienceInformation Systemsor related fieldMinimum of 10 years of experience in a data analyst role within a data warehouse environmentExpertise in SQLprogramming and database management systems (e.g.SQL ServerOracle)Minimum 3 years of Enterprise data analytical experience using Power BIProven experience in designing and implementing data mart modelsutilizing dimensional modeling techniquesStrong understanding of data validation methodologies and toolsExcellent communication and interpersonal skillsDemonstrated ability to manage multiple priorities
Nice-to-Have Skills
Power BI for data visualizationExperience in credit union or banking industriesData modeling tools like erwinCloud-based data platforms (AWSAzure)Data management certificationsKnowledge of Data Engineering and Data Science with ML
Tools & Platforms
ERwin Data ModelerPower BISQL ServerOracleAWSAzureGoogle Cloud Platform
Required Skills
Bachelor's degree in Computer ScienceInformation Systemsor related field; SQL; SQL Server; Oracle; Power BI; Dimensional Modeling; Data Warehousing; ETL; ERwin Data Modeler; Data Governance; Data Validation; AWS; Azure; Google Cloud Platform
Hard Skills
SQLSQL ServerOraclePower BIDimensional ModelingETLERwin Data ModelerData WarehousingAmazon Web ServicesAzureGoogle Cloud Platform
Soft Skills
CommunicationInterpersonal skillsClient collaborationMultitaskingTeamwork
Certifications
Preferred
Certified Data Management ProfessionalMicrosoft Power BI Data Analyst
Keywords for Your Resume
data warehouseerwin data modelersqlsql serveroraclepower bidimensional modelingdata martetldata governancedata validationawsazuregoogle cloud platformpublic trust clearanceus citizenshipgreen cardremotefederal government clientcompliancecross-functionaldata analyticsSQLSQL ServerOraclePower BIDimensional ModelingData WarehousingETLERwin Data ModelerData GovernanceAWS
Deal Breakers
Not a US citizen or green card holder, Unable to obtain Public Trust clearance, Lack of 10+ years of data warehousing experience, Lack of Power BI and data mart design experience
Get matched to jobs like this
Luna finds roles that fit your skills and career goals — no endless scrolling required.
Create a Free Profile