Senior SQL and Power BI Developer

Duration: 12 Months

Additional Information

Please note that although the position is 100% remote, the live scan will be conducted onsite at our Downey HQ location. This position is for developing Power BI dashboards with advanced DAX, data modeling, and performance tuning and a strong SQL expertise in PL/SQL and T/SQL for building and optimizing database solutions.

A Senior SQL and Power BI Developer Senior Programmer is responsible for leading and/or working on the most complex IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software. This classification may also plan, install, configure, test, implement and manage a systems environment in support of an organization’s IT architecture and business needs. Common organizational or functional industry position titles for programmers include but are not limited to programmer analyst, applications developer, software engineer, software developer, software quality assurance specialist, systems programmer, systems software programmer, database administrators, computer systems analysts, systems engineer, systems software engineer. The Senior Programmer, in development of applications software, is responsible for analyzing and refining systems requirements; translating systems requirements into applications prototypes; planning and designing systems architecture; writing, debugging and maintaining code; determining and designing applications architecture; determining output media/formats; designing user interfaces; working with customers to test applications; assuring software and systems quality and functionality; integrating hardware and software components; writing and maintaining program documentation; evaluating new applications software technologies; and/or ensuring the rigorous application of information security/information assurance policies, principles and practices to the delivery of application software services. The Senior Programmer, in development of operating systems, is responsible for analyzing systems requirements in response to business requirements, risks and costs; evaluating, selecting, verifying and validating the systems software environment; evaluating, selecting and installing compilers, assemblers and utilities; integrating hardware and software components within the systems environment; monitoring and fine-tuning performance of the systems environment; evaluating new systems engineering technologies and their effect on the operating environment; and/or ensuring that information security/information assurance policies, principles and practices are an integral element of the operating environment.

Skills

• Possess advanced knowledge of SQL, encompassing intricate query optimization techniques, nuanced data manipulation strategies, and a keen ability for fine-tuning database performance. Proficiency extends to crafting queries that operate efficiently even with large datasets, ensuring optimal processing times and minimal resource usage.
• Demonstrate expertise in working with diverse and popular database management systems such as Oracle, MySQL, SQL Server, and Azure SQL. Proficiency includes database administration, schema design, and the seamless execution of operations across various platforms, showcasing adaptability and proficiency in different environments.
• Exhibit a strong understanding and extensive experience in Oracle PL/SQL programming. This expertise encompasses the development and optimization of intricate stored procedures, triggers, and functions. Proficiency in PL/SQL ensures the seamless execution of complex tasks, enhancing database functionality and performance.
• Showcase the ability to design efficient data models that facilitate optimal storage and retrieval of information. Proficiency in creating robust data structures ensures streamlined access to relevant data, enhancing overall database efficiency and reducing query complexity.
• Demonstrate a comprehensive understanding of Extract, Transform, Load (ETL) processes and tools and scripting languages like Python, Perl, or Shell scripting for automating and data manipulation. Proficiency in integrating data from diverse sources into the database showcases the ability to harmonize disparate datasets, ensuring data consistency, accuracy, and reliability.
• Exhibit a strong ability to optimize both database queries and underlying structures. Proficiency in query optimization techniques and structural refinements enhances database performance and responsiveness. Skills in identifying and rectifying bottlenecks contribute to streamlined operations.
• Possess knowledge of data warehousing concepts and tools, enabling effective management of vast volumes of data. Expertise in data warehousing ensures efficient storage, retrieval, and analysis of large datasets, supporting the organization's data-driven decision-making processes.
• Display proficiency with Power BI, including crafting insightful visualizations and reports that translate raw data into valuable, actionable insights.
• Demonstrate proficiency in utilizing version control systems like Git to effectively manage and track changes in database scripts and queries. Expertise in version control ensures systematic tracking of modifications, enabling collaboration, maintaining code integrity, and facilitating seamless integration of changes into the database systems.

Experience Required

• his classification must have a minimum of seven (7) years of experience in electronic data processing systems study, design, and programming.
• At least four (4) years of that experience must have been in a lead capacity.

Education:

Bachelors in computer science, data analytics, or a related field.

About US Tech Solutions:

• US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
• US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Recruiter Details:

• Name: Raviteja Yarram
• Email: raviteja.y@ustechsolutionsinc.com