· Create business models, logical specifications and/or user requirements to develop solutions for the application environment
o Created data models and schemas for relational and non-relational databases to support data storage and retrieval.
o Created the Documented technical designs, processes, and procedures for future reference.
o Conducted root cause analysis for data-related issues and implemented corrective actions.
· Design software applications, create system procedures and ensure that the developed applications function normally
o Designed and implemented ETL processes to ingest data from various sources into a centralized data warehouse using Python and SQL.
o Evaluated new technologies and tools to enhance data processing capabilities and improve efficiency.
o Data governance policies and procedures to ensure data quality and compliance with regulations.
· Develop and create business models, logical specifications and/or user requirement solutions for the application environment
o Developed data pipelines to process and analyze large volumes of data, ensuring scalability and performance.
o Developed data visualization dashboards using tools like Power BI to present insights and trends to stakeholders.
o Developed and maintained data dictionaries and metadata repositories to document data sources and definitions.
· Implement and modify programs; make approved changes by amending flow charts, develop detailed programming logic, and coding changes
o Implemented data quality checks and validation processes to ensure data accuracy and integrity.
o Implemented data security measures to protect sensitive information and ensure compliance with regulations.
o Monitored AWS resources and responded to alerts and incidents, ensuring high availability and performance of production systems.
· Participate in scrum meetings and coordinate with Business Analysts to understand the business needs and implement the same into a functional design
o Collaborated with cross-functional teams to understand data requirements and design solutions that meet business needs.
o Participated in code reviews and provided technical guidance to team members.
o Collaborated with cross-functional teams to address production issues and documented troubleshooting steps, solutions, and best practices for knowledge sharing and future reference.
· Manage source code, prepare test data, tests and debug programs; revise and refine programs to improve performance of the application software
o Integrated third-party APIs and services to enrich and expand data capabilities.
o Managed and maintained AWS infrastructure, including EC2 instances, S3 buckets, RDS databases, and Lambda functions, ensuring optimal performance and cost-effectiveness. Worked on AWS to deploy and manage data infrastructure and services.
o Collaborated with business analysts to translate business requirements into technical solutions.
· Perform execution of functional test plan, validate test results, prepare documentation & data for analysis
o Optimized SQL queries and database performance to enhance overall system efficiency. Investigated and resolved issues impacting production systems, performing root cause analysis to prevent recurrence.
o Automated manual data processes using Python scripts, reducing manual effort and improving productivity.
o Conducted performance tuning and optimization of data pipelines to improve efficiency and reduce processing time.
Bachelor's Degree is required in Computer Science or Computer Engineering .
Job Type: Full-time
Schedule:
Education:
Work Location: In person