LanceSoft, Inc. · 1 day ago
Data Analyst Programmer
Las Vegas, NV
Full-time
Hybrid
Mid Level
$60/hr - $65/hr
3+ years expLanceSoft, Inc. is seeking a skilled Data Analyst Programmer to design, build, and maintain data pipelines and analytics solutions. The role involves utilizing ETL expertise and Azure data services to ensure data quality, governance, and compliance across various environments.
Information Technology
Responsibilities
Design, develop, and maintain ETL/ELT pipelines using both on-premises and cloud-based tools, including IBM InfoSphere DataStage, Microsoft SSIS, and Azure Data Factory (ADF), based on the project plan
Build and manage scalable data pipelines and storage solutions using Azure Synapse Analytics and Azure Data Lake Storage, ensuring efficient data ingestion, transformation, and retrieval, based on the project plan
Develop and optimize data solutions using Python, R, T-SQL, and PL/SQL to support analytics, reporting, and downstream applications
Work with traditional on-premises relational databases such as Oracle, SQL Server, and DB2, including performance tuning and data integration
Design and implement data models, data warehouses, and architectural frameworks that support enterprise reporting and analytics needs
Create and maintain Power BI datasets, data models, and reports, ensuring optimized performance and accurate business insights
Ensure data quality, accuracy, and reliability across all data pipelines by implementing validation, monitoring, and governance processes
Support trustworthy and compliant data analytics by maintaining traceable data lineage and enforcing governance standards throughout the data lifecycle
Collaborate with stakeholders, analysts, and data consumers to understand requirements and translate them into scalable data solutions
Deliver weekly progress reports for development team code review
Analyze and correct technical issues as found, providing weekly bug status updates
Maintain and communicate status of work performed bi-weekly at minimum
Qualification
Required
At least 3 years of professional experience in designing, building, and maintaining end-to-end data pipelines and analytics solutions across on-premises and cloud environments
Strong ETL expertise
Hands-on experience with Azure data services
Solid data modeling and warehouse design skills
Strong commitment to data quality, governance, and compliance
Expert level/Minimum three (3) years' experience in ETL development using on-premises and cloud tools
Expert level/Minimum three (3) years' experience in Python, R, T-SQL, and/or PL/SQL
Expert level/Minimum three (3) years' experience in Azure Synapse Analytics and Azure Data Lake Storage
Expert level/Minimum three (3) years' experience in design and implement data pipelines following Medallion Architecture (Bronze, Silver, Gold layers)
Advance level/Minimum one (1) year' experience in on-premises databases (Oracle, SQL Server, DB2)
Advance level/Minimum one (1) year' experience in Power BI and Power BI data modeling
Minimum one (1) year' experience in data modeling and data warehouse design and architecture for on-premises and cloud environments
Minimum one (1) year' experience in data governance, validation, monitoring, and lineage management
Preferred
Experience supporting predictive analytics or advanced analytics workloads
Familiarity with cloud-based data governance and monitoring frameworks
Demonstrates professional organization, documentation, communication, and interpersonal skills
Strong communication and collaboration skills
Company
LanceSoft, Inc.
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele.
5001-10000 employees
H1B Sponsorship
LanceSoft, Inc. 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
2025 (55)
2024 (32)
2023 (23)
2022 (25)
2021 (60)
2020 (80)
Funding
Current Stage
Late StageLeadership Team
Ram Karuppusamy
Chairman & CEO
Simon Dealy
Chief Financial Officer
Company data provided by crunchbase