> Markdown version of [/jobs/ext/3969702-programmer-analyst-data-solutions](https://www.wearedevelopers.com/jobs/ext/3969702-programmer-analyst-data-solutions). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Programmer Analyst - Data Solutions - **Company:** IDEATE TECHNOLOGIES LLC - **Location:** Charlotte, NC, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, Agile Methodology, Business Analytics Applications, Apache HTTP Server, Cloud Computing, Code Review, Databases, Information Engineering, Data Governance, Data Infrastructure, Data Integration, Data Integrity, Data Mapping, Data Transformation, Data Systems, Data Warehousing, Relational Databases, Digital Assets, Distributed Computing Environment, Distributed Data Store, Python (Programming Language), Meta-Data Management, Software Maintenance, Power BI, Cloud Services, Simple Data Format, Software Engineering, SQL Databases, Data Storage Technologies, Snowflake, Apache Spark, Git, Microsoft Fabric, Data Lakes, Pyspark, Data Lineage, AWS Data Analytics, Data Pipelines - **Published:** October 27, 2026 - **Apply:** https://www.dice.com/job-detail/aeadad77-d944-4b06-b3ea-ba10196f5155 ## About the Role * 6+ years of experience in Data Engineering, Software Development, Business Intelligence, or Data Solutions. * Strong SQL development skills and experience working with large-scale analytical datasets. * Hands-on experience with Python, Spark/PySpark, and Snowflake. * Strong understanding of relational databases, MPP databases, distributed data warehouses, and cloud data platforms. * Working knowledge of Delta Lake, Apache Iceberg, partitioning strategies, file formats, storage optimization, and query performance tuning. * Experience with data integration, transformation, pipeline development, and distributed data processing. * Understanding of cloud-native analytics platforms and modern data warehouse/lakehouse architectures. * Strong analytical, troubleshooting, and problem-solving skills. * Ability to work independently, manage priorities, and collaborate effectively with technical teams., * Microsoft Fabric: OneLake, Lakehouse, Data Factory, Notebooks, Semantic Models, and Power BI. * Snowflake data platform experience. * AWS data and analytics services. * Data governance, data quality, and metadata management. * Financial, accounting, or enterprise reporting data experience. * Financial Services industry experience. * Agile delivery methodologies and Git-based development workflows. ## Description * Analyze business and technical requirements to develop scalable data and analytics solutions. * Design, develop, test, deploy, and maintain data pipelines using SQL, Python, Spark, Snowflake, Microsoft Fabric, and related technologies. * Support new development, application maintenance, enhancements, and defect resolution. * Develop and optimize SQL queries, data transformations, and reusable data assets. * Contribute to data modeling, data mapping, metadata management, and data lineage documentation. * Implement lakehouse solutions and optimize data storage, processing, and query performance. * Investigate data quality issues, perform root cause analysis, and ensure data integrity. * Collaborate with senior engineers and architects to deliver secure, reliable, and maintainable solutions. * Participate in code reviews, testing, deployments, technical documentation, and continuous improvement. * Provide production support for cloud-based and distributed data platforms.